SUPPORT / SAMPLES & SAS NOTES
Problem Note 53828: Reading a DB2 table that contains a BLOB or CLOB data type might result in errors
 |  |  |  |  |
Querying a DB2 table and explicitly listing a column of a BLOB (binary large object) or CLOB (character large object) data type in the SELECT clause might result in an error similar to the following:
DB2 ERROR:
RESULT OF SQL STATEMENT:
DSN00804E AN ERROR WAS FOUND IN THE APPLICATION PROGRAM INPUT PARAMETERS FOR THE SQL STATEMENT, REASON 17
A DUMP OF THE SQLCA FOR THE GET DIAGNOSTICS REQUEST FOLLOWS:
ROW NUMBER: 0 ERROR CONDITION: 1 REASON CODE: 17
SQLCODE: -804 SQLSTATE: 07002 SQLERRP: DSNXROHBTo work around this issue, select all variables by specifying SELECT * in your query.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to DB2 | z/OS | 9.3 TS1M2 | 9.4 TS1M2 |